HOME > PREFERRED SUPPLIER >
 
 
") || $keywordarray[$i] == "=" || ($keywordarray[$i] == "/") || ($keywordarray[$i] == "\\") || ($keywordarray[$i] == "#") || (strlen($keywordarray[$i]) < 2)) { $novalue = "true"; $keywordarray[$i] = ""; } else { $skeyword = $skeyword . "`compnayname` like '%".$keywordarray[$i]."%' OR `product` like '%".$keywordarray[$i]."%' OR `prodtitle` like '%".$keywordarray[$i]."%' OR `proddesc` like '%".$keywordarray[$i]."%' OR `placeoforigin` like '%".$keywordarray[$i]."%' OR `type` like '%".$keywordarray[$i]."%' OR `purity` like '%".$keywordarray[$i]."%' OR `pattern` like '%".$keywordarray[$i]."%' OR `style` like '%".$keywordarray[$i]."%' OR `usage` like '%".$keywordarray[$i]."%' OR `yarncount` like '%".$keywordarray[$i]."%' OR `density` like '%".$keywordarray[$i]."%' OR `width` like '%".$keywordarray[$i]."%' OR `weight` like '%".$keywordarray[$i]."%' OR `feature` like '%".$keywordarray[$i]."%' OR `modelno` like '%".$keywordarray[$i]."%' OR `brandname` like '%".$keywordarray[$i]."%' "; } if (($i < ($keywordcount-1)) && ($novalue == "false")) { $skeyword = $skeyword . ' OR '; } //echo $i . " " . $skeyword . "


"; } } } if ($skeyword == "") { $sqlCount="SELECT count(*) FROM `newposting` WHERE `adminstatus`='Y' ".$smc.$ssc.$spc.$scountry ." ORDER BY `srno` desc "; $sqlCountexe = mysql_db_query(DB_NAME, $sqlCount); $rsCount = mysql_num_rows($sqlCountexe); $totalrows = @mysql_result($sqlCountexe, 0, 0); $limit=10; if(empty($page)){ $page = 1; } $limitvalue = ($page - 1) * $limit; $selectposting = "SELECT `memid`, `compnayname`, `maincatid`, `maincat`, `subcatid`, `subcat`, `prodid`, `product`, `prodtitle`, `proddesc`, `productimage`, `sellingtype`, `placeoforigin`, `type`, `purity`, `pattern`, `style`, `usage`, `yarncount`, `density`, `width`, `weight`, `feature`, `brandname`, `modelno`, DATE_FORMAT(`dtstamp`, '%M %D, %Y') as `dtstamp`,`srno` FROM `newposting` WHERE `adminstatus`='Y' ".$smc.$ssc.$spc.$scountry." ORDER BY `srno` desc LIMIT $limitvalue, $limit"; $selectpostingexe = mysql_db_query(DB_NAME, $selectposting); $selectpostingrow = mysql_num_rows($selectpostingexe); } else { $sqlCount="SELECT count(*) FROM `newposting` WHERE `adminstatus`='Y' ".$skeyword." ORDER BY `srno` desc "; $sqlCountexe = mysql_db_query(DB_NAME, $sqlCount); $rsCount = mysql_num_rows($sqlCountexe); $totalrows = @mysql_result($sqlCountexe, 0, 0); $limit=10; if(empty($page)){ $page = 1; } $limitvalue = ($page - 1) * $limit; $selectposting = "SELECT `memid`, `compnayname`, `maincatid`, `maincat`, `subcatid`, `subcat`, `prodid`, `product`, `prodtitle`, `proddesc`, `productimage`, `sellingtype`, `placeoforigin`, `type`, `purity`, `pattern`, `style`, `usage`, `yarncount`, `density`, `width`, `weight`, `feature`, `brandname`, `modelno`, DATE_FORMAT(`dtstamp`, '%M %D, %Y') as `dtstamp`,`srno` FROM `newposting` WHERE `adminstatus`='Y' ".$skeyword." ) ORDER BY `srno` desc LIMIT $limitvalue, $limit"; $selectpostingexe = mysql_db_query(DB_NAME, $selectposting); $selectpostingrow = mysql_num_rows($selectpostingexe); } include "closedb.php"; ?> 
Sorry currently we don't have any posting to display based on your searched criteria. Click here to try again.
"; } else { $product_image = substr($productimage, 0 ,1); if($product_image == ".") { $productimage = substr($productimage, 2); ?>  
".$keywordarray[$s]."", $prodtitle); } } echo $prodtitle; ?> [".$keywordarray[$s]."", $placeoforigin); } } echo $placeoforigin; ?>]
".$keywordarray[$s]."", $compnayname); } } echo $compnayname; ?> [".$keywordarray[$s]."", $membercountry); } } echo $membercountry; ?>] -
Supplier for ".$keywordarray[$s]."", $product); } } echo $product; ?> ".$keywordarray[$s]."", strtolower($sellingtype)); } } echo $sellingtype; ?>
".$keywordarray[$s]."", $prddesc); } } echo $prddesc; ?> Product Description : '); for ($s=0;$s<$keywordcount;$s++){ if($keywordarray[$s] != "") { $newtext = str_replace($keywordarray[$s], "".$keywordarray[$s]."", $newtext); } } echo $newtext; ?>
Select All  
Total Product(s) :
1){ $pageprev = $page-1; echo(" << prev |"); } if ($numofpages > 5) { $spage = $page - 2; $epage = $page + 2; if ( $epage > $numofpages) { $spage = $spage - 1; $epage=$numofpages; } if ($page == 1) { $spage = $page; $epage = $page + 4; } elseif ($page == 2) { $spage = $page - 1; $epage = $page + 3; } } else { if ($page == 1) { $spage = $page; $epage = $numofpages; } elseif ($page == 2) { $spage = $page - 1; $epage = $numofpages; } elseif ($page == 3) { $spage = $page - 2; $epage = $numofpages; } elseif ($page == 4) { $spage = $page - 3; $epage = $numofpages; } elseif ($page == 5) { $spage = $page - 4; $epage = $numofpages; } } for($i = $spage; $i <= $epage; $i++) { if($page == $i){ if ($epage == 1) { echo(" ".$i." "); } else { echo(" ".$i." |"); } } else { echo(" $i |"); } } if($page < $numofpages){ $pagenext = ($page + 1); echo (" next >>"); } ?>
Supplier? Click here
 
 
 
 
product category